██    ██ ██    ██  ██████  ██  ██████  ██    ██ ███████ ██████  ██    ██ 
     ██  ██  ██    ██ ██       ██ ██    ██ ██    ██ ██      ██   ██  ██  ██  
      ████   ██    ██ ██   ███ ██ ██    ██ ██    ██ █████   ██████    ████   
       ██    ██    ██ ██    ██ ██ ██ ▄▄ ██ ██    ██ ██      ██   ██    ██    
       ██     ██████   ██████  ██  ██████   ██████  ███████ ██   ██    ██    
                                      ▀▀                                     
    
Sets - Last modified: 11/01/2023 20:48 UTC
By Guilherme Ruiz

Table of Contents¶

  • 1  Data aquisition
    • 1.1  Fetch set lists
    • 1.2  Fetch set properties
    • 1.3  Merge data
    • 1.4  Save data
  • 3  Check changes
    • 3.1  Load previous data
    • 3.2  Generate changelog
  • 4  Data visualization
    • 4.1  Full data
    • 4.2  Set
    • 4.3  Card number
    • 4.4  Name
    • 4.5  Rarity
      • 4.5.1  By unique
      • 4.5.2  By combination
    • 4.6  Print
    • 4.7  Quantity
    • 4.8  Region
    • 4.9  Cover card
    • 4.10  Series
    • 4.11  Set type
    • 4.12  Release
      • 4.12.1  By year
      • 4.12.2  By month
      • 4.12.3  By day
      • 4.12.4  By region
      • 4.12.5  By series
      • 4.12.6  By set type
  • 5  Debug
    • 5.1  Has nan name/number
    • 5.2  Has nan rarity
    • 5.3  Has quantity as print
    • 5.4  Has nan release
    • 5.5  Has print as rarity
    • 5.6  Merge failed
  • 6  HTML export

Data aquisition¶

Fetch set lists¶

  0%|          | 0/80 [00:00<?, ?it/s]
4118 set lists received - 75 errors

Fetch set properties¶

  0%|          | 0/96 [00:00<?, ?it/s]
1433 set properties received - 3 errors

Merge data¶

Set properties merged

Save data¶

Data saved

Check changes¶

Load previous data¶

File loaded

Generate changelog¶

Name Rarity Print Cover card Modification date Version
Card number
CL03-SC004 <NA> NaN <NA> NaN 2022-11-07 13:43:33 Old
CL03-SC004 <NA> NaN NaN 2022-11-07 13:43:33 New
CL03-SC005 <NA> NaN <NA> NaN 2022-11-07 13:43:33 Old
CL03-SC005 <NA> NaN NaN 2022-11-07 13:43:33 New
CL03-SC006 <NA> NaN NaN 2022-11-07 13:43:33 New
... ... ... ... ... ... ...
RD/KP12-JP??? Digrace the Skysavior Radiance NaN <NA> (The Dragias, The Dragiastar, Transamuroad Rai... 2023-01-05 10:17:58 Old
RD/KP12-JP??? Dunkes the Skysavior Knight NaN <NA> (The Dragias, The Dragiastar, Transamuroad Rai... 2023-01-05 10:17:58 Old
RD/KP12-JP??? Lua the Skysavior Angel NaN <NA> (The Dragias, The Dragiastar, Transamuroad Rai... 2023-01-05 10:17:58 Old
RD/KP12-JP??? Soleil the Skysavior Angel NaN <NA> (The Dragias, The Dragiastar, Transamuroad Rai... 2023-01-05 10:17:58 Old
RD/KP12-JP??? Drukmoor the Skysavior Phantom NaN <NA> (The Dragiastar, The☆Dragias, Transamuroad Rai... 2023-01-11 11:55:38 New

482 rows × 6 columns

Changelog saved

Data visualization¶

Full data¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
0 2015 Mega-Tins CT12-SP001 Odd-Eyes Pendulum Dragon (Platinum Secret Rare,) <NA> <NA> SP 2015-09-17 <NA> Collectible tin (Dark Rebellion Xyz Dragon, Odd-Eyes Pendulum ... 2018-07-15 11:41:33 both
1 2015 Mega-Tins CT12-SP003 Elder Entity Norden (Super Rare,) <NA> <NA> SP 2015-09-17 <NA> Collectible tin (Dark Rebellion Xyz Dragon, Odd-Eyes Pendulum ... 2018-07-15 11:41:33 both
2 2015 Mega-Tins CT12-SP004 Majesty's Fiend (Super Rare,) <NA> <NA> SP 2015-09-17 <NA> Collectible tin (Dark Rebellion Xyz Dragon, Odd-Eyes Pendulum ... 2018-07-15 11:41:33 both
3 2015 Mega-Tins CT12-SP002 Dark Rebellion Xyz Dragon (Platinum Secret Rare,) <NA> <NA> SP 2015-09-17 <NA> Collectible tin (Dark Rebellion Xyz Dragon, Odd-Eyes Pendulum ... 2018-07-15 11:41:33 both
4 2015 Mega-Tins CT12-SP005 Old Entity Hastorr (Super Rare,) <NA> <NA> SP 2015-09-17 <NA> Collectible tin (Dark Rebellion Xyz Dragon, Odd-Eyes Pendulum ... 2018-07-15 11:41:33 both
... ... ... ... ... ... ... ... ... ... ... ... ... ...
155815 Jump Festa 2013 - Promotion Pack A JF13-JPA08 Fishborg Archer (Normal Parallel Rare,) New <NA> JP 2012-12-22 <NA> Booster pack NaN 2022-07-26 20:28:03 both
155816 Jump Festa 2013 - Promotion Pack A JF13-JPA09 Vulcan the Divine (Normal Parallel Rare,) New <NA> JP 2012-12-22 <NA> Booster pack NaN 2022-07-26 20:28:03 both
155817 Jump Festa 2013 - Promotion Pack A JF13-JPA10 Secret Sanctuary of the Spellcasters (Normal Parallel Rare,) New <NA> JP 2012-12-22 <NA> Booster pack NaN 2022-07-26 20:28:03 both
155818 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN 2022-12-28 20:46:20 right_only
155819 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN 2014-07-03 18:52:14 right_only

155820 rows × 13 columns

Full data available here

Set¶

Total number of sets: 1438
Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
Set
"Amabie-San" Present Campaign 2 1 1 0 0 1 1 0 1 0 1 1
"Blue-Eyes White Dragon Rush Rare Special Red Version" GET Campaign 2 1 1 0 0 2 2 0 1 0 1 1
"Blue-Eyes White Dragon Secret Rare Special Blue Version" GET Campaign 1 1 1 0 0 1 1 0 1 0 1 1
"Blue-Eyes White Dragon" 20th Anniversary Gold Edition 0 1 0 0 0 1 1 0 1 0 1 1
"Blue-Eyes White Dragon" 20th Anniversary Silver Edition 0 1 0 0 0 1 1 0 1 0 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
Yu-Gi-Oh! ZEXAL World Duel Carnival Duel Champion Guide! promotional card 1 1 1 0 0 1 1 0 1 0 1 1
Yu-Gi-Oh! ZEXAL World Duel Carnival promotional cards 18 3 1 0 0 6 2 0 1 0 1 1
Yugi's Legendary Decks 650 112 3 0 0 5 2 0 1 0 1 1
Zexal Collection Tin 120 24 3 0 0 5 1 0 1 1 1 1
Zombie World Structure Deck 185 37 2 0 2 5 1 0 1 1 1 1

1438 rows × 12 columns

Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
count 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.000000 1438.0
mean 106.747566 27.470097 2.426982 0.350487 0.099444 2.689847 1.440890 0.389430 0.953408 0.310153 0.994437 1.0
std 235.792582 45.303555 2.326788 0.814515 0.455981 2.296964 0.949114 0.487791 0.210838 0.462717 0.074406 0.0
min 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.0
25% 1.000000 1.000000 1.000000 0.000000 0.000000 1.000000 1.000000 0.000000 1.000000 0.000000 1.000000 1.0
50% 10.000000 5.000000 1.000000 0.000000 0.000000 1.000000 1.000000 0.000000 1.000000 0.000000 1.000000 1.0
75% 86.000000 40.000000 3.000000 0.000000 0.000000 5.000000 2.000000 1.000000 1.000000 1.000000 1.000000 1.0
max 1652.000000 307.000000 17.000000 6.000000 3.000000 10.000000 8.000000 1.000000 1.000000 1.000000 1.000000 1.0

Card number¶

Total number of card numbers: 151655
Set Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
Card number
15AX-JP000 2 1 1 1 0 1 1 0 1 0 2 1
15AX-JPM01 1 1 1 1 0 1 1 0 1 0 1 1
15AX-JPM02 1 1 1 1 0 1 1 0 1 0 1 1
15AX-JPM03 1 1 1 1 0 1 1 0 1 0 1 1
15AX-JPM04 1 1 1 1 0 1 1 0 1 0 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
ZTIN-SP021 1 1 1 0 0 1 1 0 1 1 1 1
ZTIN-SPV01 1 1 1 0 0 1 1 0 1 1 1 1
ZTIN-SPV02 1 1 1 0 0 1 1 0 1 1 1 1
ZTIN-SPV03 1 1 1 0 0 1 1 0 1 1 1 1
<NA> 44 406 6 2 0 10 40 6 11 6 43 3

151656 rows × 12 columns

Name¶

Total number of card names: 12552
Set Card number Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
Name
"A Legendary Ocean" 1 1 0 0 0 1 1 0 1 1 1 1
"A" Cell Breeding Device 4 9 1 1 0 7 6 1 2 3 4 1
"A" Cell Incubator 2 8 1 2 0 7 6 1 1 2 2 1
"A" Cell Recombination Device 1 8 1 0 0 8 4 1 1 1 1 1
"A" Cell Scatter Burst 3 9 1 1 0 7 6 1 1 3 3 1
... ... ... ... ... ... ... ... ... ... ... ... ...
Zubaba Knight 12 50 5 1 1 8 23 2 2 7 12 1
Zubababancho Gagagacoat 1 2 1 1 0 2 2 1 1 1 1 1
Zure, Knight of Dark World 8 24 1 1 1 10 14 1 4 4 8 1
Zushin the Sleeping Giant 3 14 3 1 0 8 4 1 2 3 3 1
<NA> 11 223 3 1 0 9 14 5 4 6 11 2

12553 rows × 12 columns

Set Card number Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
count 12552.000000 12552.000000 12552.000000 12552.000000 12552.000000 12552.000000 12552.000000 12552.000000 12552.000000 12552.000000 12552.000000 12552.000000
mean 3.147068 12.065966 2.069551 0.672084 0.112572 6.884640 5.932839 1.087715 1.474586 1.845363 3.135755 1.010835
std 3.520278 11.606018 1.500386 0.672976 0.342689 2.569579 5.715706 0.787239 0.938805 1.843292 3.499646 0.103530
min 1.000000 0.000000 0.000000 0.000000 0.000000 1.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.000000
25% 1.000000 7.000000 1.000000 0.000000 0.000000 6.000000 3.000000 1.000000 1.000000 1.000000 1.000000 1.000000
50% 2.000000 9.000000 2.000000 1.000000 0.000000 8.000000 4.000000 1.000000 1.000000 1.000000 2.000000 1.000000
75% 4.000000 14.000000 3.000000 1.000000 0.000000 8.000000 7.000000 1.000000 2.000000 2.000000 4.000000 1.000000
max 80.000000 275.000000 28.000000 4.000000 3.000000 15.000000 116.000000 12.000000 16.000000 41.000000 80.000000 2.000000

Rarity¶

Total number of rarities: 54

By unique¶

Set Card number Name Print Quantity Region Release Series Set type Cover card Modification date _merge
Rarity
10000 Secret Rare 2 7 1 1 0 7 2 1 1 2 2 1
20th Secret Rare 16 135 134 3 0 1 13 3 3 6 16 1
@released::(from July 17) 1 1 1 0 0 1 0 0 0 0 1 1
@released::(from July 31) 1 1 1 0 0 1 0 0 0 0 1 1
@released::(from September 18) 1 2 1 0 0 1 0 0 0 0 1 1
Collector's Rare 6 225 75 2 0 7 6 2 1 6 6 1
Collectors Rare 8 112 112 2 0 1 8 1 1 7 8 1
Common 560 76811 8514 6 3 17 921 25 23 268 558 2
Duel Terminal Normal Parallel Rare 38 1906 511 2 0 7 34 1 3 11 38 1
Duel Terminal Normal Rare Parallel Rare 5 15 15 0 0 1 5 0 1 4 5 1
Duel Terminal Rare Parallel Rare 34 368 141 2 0 2 31 0 1 10 34 1
Duel Terminal Secret Parallel Rare 16 103 55 1 0 1 16 0 1 10 16 1
Duel Terminal Super Parallel Rare 34 240 85 2 0 2 31 0 1 10 34 1
Duel Terminal Ultra Parallel Rare 42 371 87 2 0 7 33 1 5 18 42 1
Extra Secret Parallel Rare 3 10 6 0 0 2 4 0 2 1 3 1
Extra Secret Rare 24 77 50 1 1 3 31 3 5 17 24 1
Ghost Rare 35 255 47 3 0 7 63 1 2 34 35 1
Ghost/Gold Rare 1 30 6 0 0 5 2 1 1 0 1 1
Gold Rare 23 2057 363 2 0 9 39 3 5 0 23 1
Gold Rush Rare 2 16 16 2 0 1 2 0 1 1 2 1
Gold Secret Rare 8 644 154 2 0 9 17 1 3 0 8 1
Holographic Parallel Rare 2 2 2 1 0 1 2 0 1 0 2 1
Holographic Rare 68 123 65 2 0 6 121 3 2 65 68 1
Kaiba Corporation Common 10 10 10 0 0 1 8 0 1 0 10 1
Kaiba Corporation Rare 5 5 5 0 0 1 5 1 2 0 5 1
Kaiba Corporation Ultra Rare 3 3 3 0 0 1 3 0 2 0 3 1
Millennium Gold Rare 2 9 6 2 0 2 2 0 1 2 2 1
Millennium Rare 8 316 152 3 0 3 9 2 6 2 8 1
Millennium Secret Rare 1 4 2 1 0 2 0 0 1 1 1 1
Millennium Super Rare 1 40 20 1 0 2 0 0 1 1 1 1
Millennium Ultra Rare 1 16 8 1 0 2 0 0 1 1 1 1
Mosaic Rare 1 1290 215 0 0 6 2 0 1 1 1 1
New 2 1 18 1 1 1 2 1 2 2 2 1
Normal Parallel Rare 135 2089 1011 4 1 4 167 7 10 61 135 1
Normal Rare 80 571 295 2 0 7 150 3 2 71 80 1
Orr 1 1 1 0 0 1 1 1 1 1 1 1
Platinum Secret Rare 2 24 4 0 0 6 4 0 1 2 2 1
Prismatic Secret Rare 39 1388 361 3 0 11 49 6 4 15 39 1
Rare 249 18472 3482 7 2 15 544 13 8 177 248 2
Reprint 6 0 35 0 0 1 6 3 1 1 6 1
Rush Rare 16 102 51 0 0 2 27 1 2 13 16 1
Secret Parallel Rare 2 12 6 1 0 2 4 0 1 0 2 1
Secret Rare 373 10353 2290 11 1 15 531 20 20 200 368 2
Shatterfoil Rare 4 1482 292 0 1 7 5 1 2 4 4 1
Short Print 56 1316 234 3 0 10 110 3 1 46 56 1
Starfoil Rare 6 2019 380 0 0 6 9 1 3 4 6 1
Starlight Rare 12 316 56 2 0 6 13 1 1 12 12 1
Super Parallel Rare 6 154 82 3 1 3 10 1 3 2 6 1
Super Rare 584 20171 3880 9 1 17 950 26 20 276 580 2
Super Short Print 1 35 5 1 0 7 0 1 1 1 1 1
Ultimate Rare 115 4314 846 2 1 11 278 5 6 85 114 2
Ultra Parallel Rare 67 279 170 3 1 7 63 4 7 20 66 2
Ultra Rare 783 17903 3169 7 2 17 1064 33 26 278 781 2
Ultra Secret Rare 1 0 6 0 0 1 1 1 1 0 1 1
NaN 38 472 417 3 0 6 32 6 9 6 37 3

By combination¶

Set Card number Name Print Quantity Region Release Series Set type Cover card Modification date _merge
Rarity
(10000 Secret Rare,) 2 7 1 1 0 7 2 1 1 2 2 1
(20th Secret Rare,) 9 25 24 1 0 1 8 2 3 1 9 1
(@released::(from July 17),) 1 1 1 0 0 1 0 0 0 0 1 1
(@released::(from July 31),) 1 1 1 0 0 1 0 0 0 0 1 1
(@released::(from September 18),) 1 2 1 0 0 1 0 0 0 0 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
(Ultra Rare, Ultimate Rare, Ultra Parallel Rare) 1 1 1 0 0 1 1 1 1 1 1 1
(Ultra Rare, Ultra Parallel Rare) 22 71 67 0 0 1 16 3 2 16 21 2
(Ultra Rare, Ultra Parallel Rare, Ultimate Rare) 5 5 5 0 0 1 3 2 1 3 5 1
(Ultra Secret Rare,) 1 0 6 0 0 1 1 1 1 0 1 1
NaN 38 472 417 3 0 6 32 6 9 6 37 3

125 rows × 12 columns

Print¶

Total number of prints: 18
Set Card number Name Rarity Quantity Region Release Series Set type Cover card Modification date _merge
Print
1 167 0 0 0 1 1 1 1 0 1 1
2 1 0 1 0 0 1 1 0 1 1 1 1
American debut 1 3 3 1 0 1 1 0 1 1 1 1
European & Oceanian debut 1 6 6 1 0 1 1 0 1 0 1 1
European debut 12 146 146 5 0 2 10 0 2 1 12 1
Functional errata 1 2 2 1 0 1 1 0 1 1 1 1
New 227 11562 3862 50 3 11 243 18 13 129 225 2
New art 1 4 2 1 0 2 2 0 1 1 1 1
New artwork 10 74 15 5 0 7 12 3 4 4 10 1
New artwork (renamed) 1 3 3 1 0 1 1 0 1 0 1 1
North American debut 2 4 4 2 0 2 2 0 2 0 2 1
Oceanian debut 1 1 1 1 0 1 1 0 1 0 1 1
Reprint 224 13920 4291 49 3 11 240 17 12 127 222 2
Reprint (New Art) 2 2 1 2 0 2 2 1 1 1 2 1
Reprint (functional errata) 15 33 21 10 0 8 14 3 3 5 15 1
Reprint (new artwork) 1 1 1 1 0 1 1 0 1 1 1 1
Reprint (renamed) 2 76 76 6 0 1 2 1 1 0 2 1
TCG legal debut 1 1 1 1 0 1 1 1 1 1 1 1
<NA> 1357 125827 11452 113 3 17 1450 41 37 315 1349 3

Quantity¶

Total number of quantities: 3
Set Card number Name Rarity Print Region Release Series Set type Cover card Modification date _merge
Quantity
1 67 8858 1215 11 2 11 108 1 6 46 66 2
2 66 855 173 4 2 11 108 1 6 45 65 2
3 10 74 25 1 2 8 12 0 4 8 10 1
<NA> 1373 141880 12443 123 18 17 1499 45 36 314 1365 3

Region¶

Total number of regions: 17
Set Card number Name Rarity Print Quantity Release Series Set type Cover card Modification date _merge
Region
AE 34 1527 1493 12 0 2 31 2 7 19 34 1
AU 2 100 87 3 0 0 0 0 1 2 2 1
DE 454 20312 10354 45 4 3 382 12 18 218 453 2
EN 657 20183 10480 51 14 3 535 22 23 207 656 2
ES 1 100 100 7 0 0 0 1 1 1 1 1
EU 25 543 456 8 3 0 15 2 9 6 25 1
FC 3 102 87 3 0 0 1 0 2 2 3 1
FR 448 19719 10341 46 4 3 376 14 18 218 447 2
IT 446 19991 10349 46 4 3 377 12 18 217 445 2
JA 3 185 185 8 0 0 3 2 2 3 3 1
JP 718 19123 11188 92 7 3 530 28 28 247 713 2
KR 382 15869 10687 55 4 3 332 16 15 223 377 2
NA 47 1526 1333 10 4 2 39 5 11 12 47 1
PT 203 12401 7783 40 4 3 165 8 10 119 203 1
SC 23 1237 1026 12 3 0 23 5 1 12 23 1
SP 415 19051 10181 45 4 3 355 9 17 203 414 2
TC 7 300 286 12 0 2 5 2 2 3 7 1
<NA> 2 0 0 0 0 0 0 0 0 0 2 1
Set Card number Name Rarity Print Quantity Release Series Set type Cover card Modification date _merge
count 18.000000 18.000000 18.000000 18.00000 18.000000 18.000000 18.000000 18.000000 18.000000 18.000000 18.000000 18.000000
mean 215.000000 8459.388889 4800.888889 27.50000 3.055556 1.666667 176.055556 7.777778 10.166667 95.111111 214.166667 1.388889
std 252.611303 9271.039450 5001.288397 25.53717 3.489012 1.414214 203.698010 8.156957 8.759868 105.433497 251.520611 0.501631
min 1.000000 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.000000 1.000000
25% 4.000000 213.750000 210.250000 8.00000 0.000000 0.000000 3.500000 2.000000 2.000000 3.000000 4.000000 1.000000
50% 40.500000 1526.500000 1413.000000 12.00000 3.500000 2.000000 35.000000 5.000000 9.500000 15.500000 40.500000 1.000000
75% 438.250000 19105.000000 10347.000000 45.75000 4.000000 3.000000 370.750000 12.000000 17.750000 214.500000 437.250000 2.000000
max 718.000000 20312.000000 11188.000000 92.00000 14.000000 3.000000 535.000000 28.000000 28.000000 247.000000 713.000000 2.000000

Cover card¶

Total number of cover cards: 671
Set Card number Name Rarity Print Quantity Region Release Series Set type Modification date _merge
Cover card
A-to-Z-Dragon Buster Cannon 1 352 54 4 2 2 8 4 0 1 1 1
Accel Synchro Stardust Dragon 1 100 50 3 2 0 2 2 0 1 1 1
Accesscode Talker 1 766 101 16 2 0 8 3 1 1 1 1
Adamancipator Risen - Dragite 1 135 45 3 2 0 3 3 0 1 1 1
Adreus, Keeper of Armageddon 1 84 42 4 0 0 2 2 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
Yamiterasu the Divine Delayer 1 132 66 6 0 0 2 2 1 1 1 1
Yoko, the Graceful Mayakashi 2 450 60 4 2 0 8 3 0 1 2 1
Yubel - The Ultimate Nightmare 2 560 100 10 0 0 6 5 1 2 2 1
Z-Metal Tank 1 55 55 7 0 0 1 1 1 1 1 1
Zerrziel, Ruler of the Evil Eyed 1 90 45 3 2 0 2 2 0 1 1 1

671 rows × 12 columns

Series¶

Total number of series: 45
Set Card number Name Rarity Print Quantity Region Release Set type Cover card Modification date _merge
Series
+1 Bonus Pack 6 230 118 3 0 0 2 11 1 0 6 1
Animation Chronicle 2 200 100 7 2 0 2 4 1 2 2 1
Astral Pack 7 1110 184 4 4 0 6 16 1 0 7 1
Attribute Duelist Pack 4 429 199 6 3 0 3 9 1 4 4 1
Battle Pack (Rush Duel) 8 80 80 3 3 0 1 8 1 0 8 1
Booster (series) 4 181 176 8 0 0 1 4 1 2 4 1
Booster pack 1 50 50 3 0 0 1 1 1 0 1 1
Champion Pack 8 640 161 4 2 0 4 8 1 0 8 1
Classic Pack 3 570 403 9 3 0 1 3 1 2 3 1
Collectors Pack 8 794 374 12 3 0 3 16 1 8 8 1
Core Booster 88 49929 7463 39 2 0 14 296 1 80 88 1
Deck Build Pack 3 360 134 5 2 0 3 8 1 3 3 1
Deck Mod Pack 12 1380 738 8 0 0 2 22 1 12 12 1
Duelist Pack 21 3739 634 7 3 0 8 49 1 19 21 1
Entry Pack (series) 10 163 160 3 2 0 1 10 1 0 10 1
Expansion Pack 4 280 280 6 0 0 1 4 1 0 4 1
Gold Series (series) 8 2595 446 9 2 0 9 18 1 0 8 1
Hidden Arsenal (series) 7 2470 400 2 2 0 7 16 1 7 7 1
Hobby League 1 83 43 3 0 0 5 0 1 0 1 1
Jump Victory Carnival 1 1 1 1 0 0 1 1 1 0 1 1
Legend Duelist (series) 6 780 343 9 2 0 3 14 1 6 6 1
Legendary Collection (series) 2 57 19 1 2 0 3 4 1 0 2 1
Master Guide promotional cards (series) 4 8 8 1 0 0 1 4 1 0 4 1
Mattel Action Figure promotional cards 3 17 16 1 0 0 1 3 1 0 3 1
McDonald's Promotional Cards 2 35 35 4 3 0 2 2 1 0 2 1
Monster Figure Collection promotional cards 3 15 15 1 0 0 1 3 1 0 3 1
OTS Tournament Pack 2 324 54 4 0 0 6 3 1 0 2 1
Perfect Rulebook promotional cards 3 3 3 2 0 0 1 3 1 0 3 1
Pharaoh Tour promotional cards 3 20 5 2 0 0 4 3 1 0 3 1
Premium Pack 25 452 368 9 3 0 2 25 1 12 25 1
Shonen Jump promotional cards 78 85 81 2 0 0 2 44 1 0 78 1
Sneak Peek Participation Cards 57 302 61 2 0 0 8 69 1 0 57 1
Star Pack 3 900 149 4 0 0 6 6 1 3 3 1
Structure Deck R 3 248 122 5 2 2 2 6 1 3 3 1
The Valuable Book promotional cards 18 38 38 2 0 0 2 19 1 0 18 1
V Jump August 1999 Special Present 1 0 6 1 0 0 1 1 1 0 1 1
V Jump Edition (series) 4 16 16 3 0 0 1 4 1 0 4 1
V Jump promotional cards 78 94 98 5 0 0 1 74 1 0 78 1
Value Box 9 11 11 3 0 0 1 7 1 0 9 1
Yu-Gi-Oh! 5D's manga promotional cards 9 19 9 1 0 0 3 18 1 0 9 1
Yu-Gi-Oh! Day promotional cards 7 7 1 1 0 0 2 7 1 0 7 1
Yu-Gi-Oh! GX manga promotional cards 9 19 9 2 0 0 3 17 1 0 9 1
Yu-Gi-Oh! R promotional cards 4 8 4 2 0 0 2 8 1 0 4 1
Yu-Gi-Oh! World Championship prize cards 13 35 30 5 0 0 3 13 1 0 13 1
Yu-Gi-Oh! ZEXAL manga promotional cards 8 25 8 1 0 0 4 25 1 0 8 1

Set type¶

Total number of set types: 37
Set Card number Name Rarity Print Quantity Region Release Series Cover card Modification date _merge
Set type
Beta set 1 535 106 1 0 2 5 1 0 0 1 1
Binder 2 6 6 2 2 0 1 2 0 0 2 1
Book promotional card 4 5 5 3 0 0 2 4 1 0 4 1
Book promotional cards 26 52 52 4 0 0 2 27 2 0 26 1
Booster pack 469 113674 11734 102 16 0 15 808 23 223 469 1
Boss Duel Deck 1 8 8 1 0 0 1 1 0 0 1 1
Bundle 9 11 11 3 0 0 1 7 1 0 9 1
Collectible tin 53 5901 1005 9 4 0 8 66 0 35 53 1
Collector's Set 11 6226 1102 7 2 3 7 14 0 6 11 1
Core Booster 1 160 80 6 0 0 2 2 0 1 1 1
Deluxe Edition 4 114 19 2 0 0 6 8 0 4 4 1
Demo Deck 4 380 64 1 0 0 7 8 0 1 4 1
Duel Disk 2 16 9 2 2 0 2 4 0 0 2 1
Duel Disk promotional cards 5 13 12 4 0 0 2 5 0 0 5 1
Duel Terminal 34 1847 706 6 2 0 2 31 0 10 34 1
Duelist League participation cards 10 60 16 3 0 0 9 9 0 0 10 1
Duelist Set 5 312 154 5 0 2 2 5 0 5 5 1
Enhancement Pack 2 20 20 1 0 0 1 1 0 0 2 1
Hobby League participation cards 40 83 43 3 0 0 5 38 0 0 40 1
Magazine promotional card 167 191 173 9 0 0 3 127 3 7 167 1
Magazine promotional cards 4 4 4 1 0 0 2 2 0 0 4 1
Main Deck 2 44 44 2 0 0 1 2 0 1 2 1
Manga promotional card 33 74 32 2 0 0 4 69 4 0 33 1
Participation card 60 485 119 5 0 0 9 71 2 0 60 1
Preconstructed Deck 6 401 223 10 3 3 2 8 0 4 6 1
Prize card 16 46 41 5 0 0 3 16 1 0 16 1
Prize cards 1 68 20 1 0 0 5 1 0 0 1 1
Promotional card 141 320 212 18 3 0 9 142 6 21 141 1
Promotional cards 25 200 62 7 2 0 10 34 1 1 25 1
Special Edition 90 1189 289 9 5 0 10 109 0 1 90 1
Starter Deck 38 6777 606 11 3 3 14 51 0 26 38 1
Structure Deck 64 9454 1206 9 2 3 10 117 1 45 64 1
Tournament prize card 1 2 2 1 0 0 1 1 0 0 1 1
Tournament promotional card 2 5 2 2 0 0 2 2 0 0 2 1
Vendor Edition 6 210 210 2 0 0 1 6 0 0 6 1
Video game promotional card 9 79 39 4 0 0 8 15 0 0 9 1
Video games promotional card 23 328 73 4 2 0 9 44 0 0 23 1

Release¶

Total number of release dates: 1570
Set Card number Name Rarity Print Quantity Region Series Set type Cover card Modification date _merge
Release
1999-03-01 1 0 40 1 0 0 1 1 1 0 1 1
1999-03-18 1 0 1 0 0 0 1 0 1 0 1 1
1999-04-29 1 0 1 0 0 0 1 0 1 0 1 1
1999-05-05 1 0 1 0 0 0 1 0 1 0 1 1
1999-05-25 1 0 40 1 0 0 1 1 1 0 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
2023-01-21 1 68 51 7 0 0 1 1 1 1 1 1
2023-02-25 1 190 23 5 3 0 1 1 1 0 1 1
2023-03-01 3 2 3 2 0 0 1 0 1 0 3 1
2023-05-01 3 3 3 1 0 0 1 0 1 0 3 1
NaT 125 4413 1294 28 4 2 15 9 14 19 117 3

1571 rows × 12 columns

By year¶

Set Card number Name Rarity Print Quantity Region Series Set type Cover card _merge
Release
1999 18 0 353 10 2 0 15 8 15 1 15
2000 11 268 318 21 2 2 9 7 10 4 9
2001 13 311 313 30 7 4 13 5 12 7 13
2002 24 1753 1292 84 8 2 25 9 21 16 20
2003 45 2596 1973 115 12 0 52 12 38 22 36
2004 79 5852 4165 190 6 0 108 27 69 31 59
2005 75 7826 4043 160 27 18 127 28 64 37 49
2006 102 5244 3048 186 22 20 125 39 93 42 67
2007 127 5747 3347 273 16 18 192 53 116 54 94
2008 125 5989 3258 269 21 12 194 51 113 50 95
2009 118 5114 2983 280 6 14 172 40 111 54 93
2010 138 6093 3322 309 8 16 204 58 124 53 103
2011 144 6922 3952 318 16 18 214 55 133 53 105
2012 142 10281 5435 351 19 20 218 57 128 53 111
2013 146 8813 4469 340 18 24 221 68 129 69 108
2014 141 12625 5705 381 38 20 225 68 126 60 107
2015 136 10432 4828 353 33 12 221 69 125 57 103
2016 137 10356 4755 331 39 10 210 62 124 59 97
2017 67 8404 3324 198 27 6 140 29 64 35 54
2018 46 5413 2129 140 26 0 103 20 41 28 41
2019 50 6264 2670 160 29 0 101 17 45 25 43
2020 38 6435 2143 150 34 0 85 18 36 27 36
2021 65 6812 2733 241 46 6 91 38 53 36 49
2022 73 8953 3673 249 66 6 96 43 61 42 56
2023 12 429 238 30 8 0 8 5 7 3 7

By month¶

By day¶

By region¶

Set Card number Name Rarity Print Quantity Series Set type Cover card Modification date _merge
Region Release
AE 2001-06-04 1 0 2 0 0 0 0 0 0 1 1
2002-08-08 2 100 87 3 0 0 0 1 2 2 1
2002-10-24 1 144 144 5 0 0 1 1 1 1 1
2003-04-17 1 3 3 1 0 0 0 1 0 1 1
2003-06-26 1 105 105 5 0 0 1 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
TC 2014-01-29 1 40 40 4 0 2 0 1 1 1 1
2014-05-01 1 20 20 4 0 0 1 1 0 1 1
2015-03-01 2 40 26 1 0 0 0 0 0 2 1
2015-08-29 1 100 100 6 0 0 1 1 1 1 1
2015-12-05 1 100 100 6 0 0 1 1 1 1 1

3169 rows × 11 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 ... 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Region
AE 0 0 1 3 4 3 3 5 2 1 ... 1 1 0 0 0 0 0 0 0 0
DE 0 0 0 2 8 19 22 17 31 27 ... 30 27 28 20 15 13 10 8 7 0
EN 0 0 2 2 3 16 29 48 50 45 ... 43 34 35 20 15 13 10 12 11 1
EU 0 0 0 0 2 4 0 0 0 2 ... 2 2 1 0 0 0 0 0 0 0
FC 0 0 0 0 2 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
FR 0 0 0 2 6 18 22 17 31 27 ... 28 27 28 19 15 13 10 8 7 0
IT 0 0 0 2 5 18 21 17 31 27 ... 28 27 28 20 15 13 10 8 7 0
JA 0 0 0 0 0 0 0 0 0 0 ... 3 0 0 0 0 0 0 0 0 0
JP 18 11 10 11 11 20 24 27 33 41 ... 43 43 52 14 16 20 14 25 26 9
KR 0 0 0 0 2 8 7 13 20 24 ... 23 22 21 17 10 12 10 23 26 0
NA 0 0 0 5 16 6 0 2 2 1 ... 2 3 0 2 0 0 0 0 0 0
PT 0 0 0 2 0 5 6 0 0 0 ... 24 25 26 18 14 13 9 8 7 0
SC 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 4 7 10 2
SP 0 0 0 2 4 18 20 10 24 22 ... 28 27 28 19 14 13 10 9 7 0
TC 0 0 0 0 0 0 0 0 0 0 ... 2 4 0 0 0 0 0 0 0 0

15 rows × 25 columns

By series¶

Set Card number Name Rarity Print Quantity Region Set type Cover card Modification date _merge
Series Release
+1 Bonus Pack 2020-10-31 1 19 19 3 0 0 1 1 0 1 1
2021-02-04 1 20 20 3 0 0 1 1 0 1 1
2021-04-17 1 19 19 3 0 0 1 1 0 1 1
2021-07-17 1 19 19 3 0 0 1 1 0 1 1
2021-07-21 1 19 19 3 0 0 1 1 0 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
Yu-Gi-Oh! ZEXAL manga promotional cards 2015-09-01 1 1 1 1 0 0 1 1 0 1 1
2015-10-03 1 1 1 1 0 0 1 1 0 1 1
2015-12-18 1 1 1 1 0 0 1 1 0 1 1
2016-03-01 1 1 1 1 0 0 1 1 0 1 1
2016-09-06 1 1 1 1 0 0 1 1 0 1 1

886 rows × 11 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 ... 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Series
+1 Bonus Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 1 6 4 0
Animation Chronicle 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 2 2 0
Astral Pack 0 0 0 0 0 0 0 0 0 0 ... 8 3 0 0 0 0 0 0 0 0
Attribute Duelist Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 2 3 4 0
Battle Pack (Rush Duel) 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 3 4 1
Booster (series) 0 3 1 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Booster pack 0 1 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Champion Pack 0 0 0 0 0 0 0 1 3 3 ... 0 0 0 0 0 0 0 0 0 0
Classic Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 2 1
Collectors Pack 0 0 0 0 0 0 0 0 0 0 ... 2 2 2 2 2 2 2 0 0 0
Core Booster 6 0 2 6 11 22 17 17 25 13 ... 16 17 16 12 10 8 6 8 8 1
Deck Build Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 2 6 0
Deck Mod Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 4 9 8 1
Duelist Pack 0 0 0 0 0 0 2 9 9 10 ... 1 3 5 1 0 0 0 0 0 0
Entry Pack (series) 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 1 4 4 1
Expansion Pack 0 0 0 0 0 0 0 0 0 3 ... 0 0 0 0 0 0 0 0 0 0
Gold Series (series) 0 0 0 0 0 0 0 0 0 2 ... 5 2 2 0 0 0 0 0 0 0
Hidden Arsenal (series) 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Jump Victory Carnival 0 0 0 0 0 0 0 0 0 0 ... 0 1 0 0 0 0 0 0 0 0
Legend Duelist (series) 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 3 4 4 1 1 1 0
Legendary Collection (series) 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Master Guide promotional cards (series) 0 0 0 0 0 1 0 0 0 1 ... 1 0 0 0 0 0 0 0 0 0
Mattel Action Figure promotional cards 0 0 0 0 0 0 0 3 0 0 ... 0 0 0 0 0 0 0 0 0 0
McDonald's Promotional Cards 0 0 0 1 0 0 0 1 0 0 ... 0 0 0 0 0 0 0 0 0 0
Monster Figure Collection promotional cards 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
OTS Tournament Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 3 0 0 0 0 0 0 0
Perfect Rulebook promotional cards 0 0 0 0 0 0 0 0 0 0 ... 1 1 1 0 0 0 0 0 0 0
Pharaoh Tour promotional cards 0 0 0 0 0 0 1 1 1 0 ... 0 0 0 0 0 0 0 0 0 0
Premium Pack 0 2 2 0 0 3 1 1 1 2 ... 2 2 0 0 0 0 0 0 0 0
Shonen Jump promotional cards 0 0 0 0 0 0 2 3 4 3 ... 6 4 6 1 0 0 0 0 0 0
Sneak Peek Participation Cards 0 0 0 0 0 0 4 4 9 8 ... 4 4 5 5 3 2 1 0 0 0
Star Pack 0 0 0 0 0 0 0 0 0 0 ... 1 2 0 0 0 0 0 0 0 0
Structure Deck R 0 0 0 0 0 0 0 0 0 0 ... 0 1 4 1 0 0 0 0 0 0
The Valuable Book promotional cards 1 1 0 2 1 1 1 1 1 1 ... 1 1 0 1 0 0 0 0 0 0
V Jump August 1999 Special Present 1 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
V Jump Edition (series) 0 0 0 0 0 0 0 0 0 0 ... 0 1 1 0 1 1 0 0 0 0
V Jump promotional cards 0 0 0 0 0 0 0 0 0 5 ... 8 11 13 2 0 0 0 0 0 0
Value Box 0 0 0 0 0 0 0 0 0 0 ... 1 1 0 0 0 0 0 0 0 0
Yu-Gi-Oh! 5D's manga promotional cards 0 0 0 0 0 0 0 0 0 0 ... 3 3 1 0 0 0 0 0 0 0
Yu-Gi-Oh! Day promotional cards 0 0 0 0 0 0 0 0 0 0 ... 2 2 2 1 0 0 0 0 0 0
Yu-Gi-Oh! GX manga promotional cards 0 0 0 0 0 0 0 1 2 3 ... 0 0 0 0 0 0 0 0 0 0
Yu-Gi-Oh! R promotional cards 0 0 0 0 0 0 1 1 1 1 ... 0 0 0 0 0 0 0 0 0 0
Yu-Gi-Oh! World Championship prize cards 0 0 0 0 0 1 1 1 1 1 ... 1 1 1 0 0 0 0 0 0 0
Yu-Gi-Oh! ZEXAL manga promotional cards 0 0 0 0 0 0 0 0 0 0 ... 6 7 2 0 0 0 0 0 0 0

44 rows × 25 columns

By set type¶

Set Card number Name Rarity Print Quantity Region Series Cover card Modification date _merge
Set type Release
Beta set 2017-10-04 1 535 106 1 0 2 5 0 0 1 1
Binder 2012-09-21 1 3 3 1 2 0 1 0 0 1 1
2015-04-29 1 3 3 1 0 0 1 0 0 1 1
Book promotional card 2004-12-18 1 2 2 1 0 0 1 0 0 1 1
2014-04-04 1 1 1 1 0 0 1 1 0 1 1
... ... ... ... ... ... ... ... ... ... ... ... ...
Video games promotional card 2011-04-28 1 7 7 1 0 0 1 0 0 1 1
2011-05-10 1 3 3 1 0 0 1 0 0 1 1
2013-12-05 1 3 3 1 0 0 1 0 0 1 1
2014-06-26 1 15 3 1 0 0 5 0 0 1 1
2016-07-16 1 1 1 1 0 0 1 0 0 1 1

1858 rows × 11 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 ... 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Set type
Beta set 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 1 0 0 0 0 0 0
Binder 0 0 0 0 0 0 0 0 0 0 ... 0 1 0 0 0 0 0 0 0 0
Book promotional card 0 0 0 0 0 1 0 0 0 0 ... 1 1 1 0 0 0 0 0 0 0
Book promotional cards 1 2 0 2 1 2 1 1 1 2 ... 2 2 1 1 0 0 0 0 0 0
Booster pack 6 6 5 10 15 40 34 36 44 44 ... 65 56 52 38 28 31 31 52 53 6
Boss Duel Deck 0 0 0 0 0 0 0 0 0 0 ... 1 0 0 0 0 0 0 0 0 0
Bundle 0 0 0 0 0 0 0 0 0 0 ... 1 1 0 0 0 0 0 0 0 0
Collectible tin 0 0 0 1 2 2 2 3 3 7 ... 2 2 2 2 1 2 1 1 1 0
Collector's Set 0 0 0 0 0 0 0 0 0 0 ... 0 2 2 0 0 3 2 1 4 0
Core Booster 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Deluxe Edition 0 0 0 0 0 0 0 0 0 0 ... 6 0 0 0 0 0 0 0 0 0
Demo Deck 0 0 0 0 0 0 0 0 0 0 ... 0 2 2 0 3 0 0 0 0 0
Duel Disk 0 0 0 0 0 0 0 1 1 0 ... 0 0 0 0 0 0 0 0 0 0
Duel Disk promotional cards 0 0 0 0 0 0 0 1 1 0 ... 0 0 0 0 0 0 0 0 0 0
Duel Terminal 0 0 0 0 0 0 0 0 0 6 ... 0 0 0 0 0 0 0 0 0 0
Duelist League participation cards 0 0 0 0 4 4 2 2 0 0 ... 0 0 0 0 0 0 0 0 0 0
Duelist Set 0 0 0 0 0 0 0 0 0 0 ... 1 0 0 0 0 0 0 0 0 0
Enhancement Pack 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Hobby League participation cards 0 0 0 0 0 2 1 13 12 12 ... 0 0 0 0 0 0 0 0 0 0
Magazine promotional card 1 0 0 0 0 0 3 3 4 10 ... 14 15 20 3 0 0 0 0 0 0
Magazine promotional cards 0 0 0 0 1 1 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Main Deck 0 0 0 0 0 0 0 0 0 1 ... 0 0 0 0 0 0 0 0 0 0
Manga promotional card 0 0 0 1 0 0 1 4 3 4 ... 9 10 3 0 0 0 0 0 0 0
Participation card 1 0 0 0 0 0 4 4 9 8 ... 4 4 5 5 3 2 1 0 0 0
Preconstructed Deck 0 0 0 0 0 0 0 0 0 0 ... 1 1 1 1 1 1 0 0 4 0
Prize card 0 0 2 0 0 1 1 1 1 1 ... 1 1 1 0 0 0 0 0 0 0
Prize cards 0 0 0 0 0 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Promotional card 2 0 2 1 0 1 1 9 9 5 ... 5 7 17 5 3 6 2 9 11 6
Promotional cards 2 0 1 1 5 7 2 1 0 0 ... 2 1 0 0 0 1 0 0 0 0
Special Edition 0 0 0 0 2 3 3 7 12 11 ... 3 7 8 7 4 2 1 0 0 0
Starter Deck 1 1 0 6 6 4 2 0 3 2 ... 5 7 4 0 0 0 0 2 0 0
Structure Deck 0 0 2 1 3 0 8 10 8 6 ... 11 13 17 4 0 0 0 0 0 0
Tournament prize card 0 0 0 0 1 0 0 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Tournament promotional card 0 0 0 0 1 0 1 0 0 0 ... 0 0 0 0 0 0 0 0 0 0
Vendor Edition 0 0 0 0 0 1 2 2 1 0 ... 0 0 0 0 0 0 0 0 0 0
Video game promotional card 1 2 0 0 0 0 0 0 5 0 ... 0 0 0 0 0 0 0 0 0 0
Video games promotional card 0 0 0 1 4 8 7 4 8 4 ... 1 0 1 0 0 0 0 0 0 0

37 rows × 25 columns

Debug¶

This section is used for debugging the extraction of data from MediaWiki query responses

Has nan name/number¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
7119 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> SP 2016-10-06 <NA> Collector's Set NaN 2022-01-18 14:06:23 both
7164 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> SP 2016-10-06 <NA> Collector's Set NaN 2022-01-18 14:06:23 both
7209 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> SP 2016-10-06 <NA> Collector's Set NaN 2022-01-18 14:06:23 both
7257 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> IT 2016-10-06 <NA> Collector's Set NaN 2022-01-18 14:06:23 both
7302 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> IT 2016-10-06 <NA> Collector's Set NaN 2022-01-18 14:06:23 both
... ... ... ... ... ... ... ... ... ... ... ... ... ...
144801 EX Starter Box <NA> De-Spell None 2 <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144802 EX Starter Box <NA> Castle Walls None Reprint <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144803 EX Starter Box <NA> Ultimate Offering None Reprint <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
155818 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN 2022-12-28 20:46:20 right_only
155819 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN 2014-07-03 18:52:14 right_only

782 rows × 13 columns

Has nan rarity¶

array(['Dark Revelation Volume 1',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome prize cards',
       'Dark Beginning 2', 'Starter Box pre-order promotional card',
       'Dark Revelation Volume 2', 'Advanced Tournament Pack 2013 Vol.4',
       'Duel Monsters II tournament meeting experience promotional card',
       'Official Guide Starter Book promotional card',
       'The Valuable Book 1 promotional cards', 'Jump Festa 2000',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome participation cards',
       'The Valuable Book character cards',
       'Advanced Tournament Pack 2016 Vol.1',
       'Advanced Event Pack 2013 Vol.2', 'Dark Beginning 1',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome attendance cards',
       'Yu-Gi-Oh! True Duel Monsters: Sealed Memories promotional cards',
       'Advanced Event Pack 2014 Vol.1',
       'Advanced Tournament Pack 2013 Vol.3',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome invitation cards',
       'V Jump April 2013 Tokens',
       '"Blue-Eyes White Dragon" 20th Anniversary Gold Edition',
       '"Blue-Eyes White Dragon" 20th Anniversary Silver Edition',
       '"Dark Magician" Special Card',
       '"Dark Magician Girl" Special Card',
       '25th Anniversary Ultimate Kaiba Set',
       'Asian-English Weekly Shōnen Jump lottery prize cards',
       'Booster 1', 'Booster 3',
       'Challenge from Kaiba Corporation Clear bonus',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Classic Pack 03', 'Cyberstorm Access',
       'Deck Build Pack: Tactical Masters',
       'Deck Mod Pack: Double Star of the Assault!!', 'EX Starter Box',
       'Academia Disk', 'Structure Deck: Marik (disambiguation)'],
      dtype=object)

Has quantity as print¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
144752 EX Starter Box <NA> De-Spell None 2 <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144801 EX Starter Box <NA> De-Spell None 2 <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
144704 EX Starter Box <NA> Lord of D. (New,) <NA> <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144705 EX Starter Box <NA> The Flute of Summoning Dragon (New,) <NA> <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144706 EX Starter Box <NA> Dark Magician None <NA> <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144707 EX Starter Box <NA> Mystical Elf None <NA> <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144708 EX Starter Box <NA> Feral Imp None <NA> <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
... ... ... ... ... ... ... ... ... ... ... ... ... ...
144799 EX Starter Box <NA> Reverse Trap None Reprint <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144800 EX Starter Box <NA> Remove Trap None Reprint <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144801 EX Starter Box <NA> De-Spell None 2 <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144802 EX Starter Box <NA> Castle Walls None Reprint <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both
144803 EX Starter Box <NA> Ultimate Offering None Reprint <NA> JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) 2022-05-01 06:51:59 both

100 rows × 13 columns

Has nan release¶

array(['Gold Series', 'Sneak Peek Participation Cards',
       'Starter Deck: Kaiba Evolution',
       'The New Challengers Sneak Peek Participation Card',
       'Yu-Gi-Oh! Worldwide Edition: Stairway to the Destined Duel promotional cards',
       'Secrets of Eternity Sneak Peek Participation Card',
       'Shonen Jump May 2006 subscription bonus',
       'The Sanctuary in the Sky', 'Yu-Gi-Oh! R promotional cards',
       'Hobby League participation cards',
       'Shonen Jump Vol. 10, Issue 4 promotional card',
       'Shonen Jump Vol. 3, Issue 9 promotional card',
       'Starter Deck: Yugi',
       "Yu-Gi-Oh! 5D's World Championship 2011: Over the Nexus promotional cards",
       'Legacy of the Valiant Sneak Peek Participation Card',
       'Raging Battle Sneak Peek Participation Card',
       'Shadow Specters Sneak Peek Participation Card',
       'Shonen Jump Scholastic Edition Vol. 9, Issue 1 promotional card',
       'Tournament Pack 2009 Vol.4', 'Premium Pack',
       'Shadow of Infinity: Special Edition',
       'Shonen Jump Vol. 7, Issue 9 promotional card',
       'Structure Deck: Marik',
       "Yu-Gi-Oh! 5D's Wheelie Breakers promotional cards",
       'Yu-Gi-Oh! GX Volume 4 promotional card',
       'Hobby League 7 participation card A', 'Millennium Pack',
       'Shonen Jump Vol. 9, Issue 6 promotional card',
       'National Championship 2013',
       'Shonen Jump Vol. 5, Issue 1 promotional card',
       'The Lost Millennium: Special Edition', 'Astral Pack One',
       'Shonen Jump May 2008 subscription bonus', 'Spell Ruler',
       'Starter Deck: Kaiba', 'Yu-Gi-Oh! GX manga promotional cards',
       'Astral Pack Two',
       'Dimension of Chaos Sneak Peek Participation Card',
       'Hobby League 6 participation card B', 'Premium Pack 2',
       'Shonen Jump June/July 2011 subscription bonus',
       'Shonen Jump Vol. 7, Issue 3 promotional card',
       'Structure Deck: Machine Re-Volt Special Edition',
       'Yu-Gi-Oh! Power of Chaos: Kaiba the Revenge promotional cards',
       'Tournament Pack 2009 Vol.3', 'Duelist League Demo 2010',
       'Shonen Jump August 2008 subscription bonus',
       'Invasion: Vengeance Sneak Peek Participation Card',
       'Starter Deck: Joey', 'Starter Deck: Pegasus',
       'The Valuable Book promotional cards',
       "Yu-Gi-Oh! 5D's Volume 1 promotional card", 'Invader of Darkness',
       "Structure Deck: Dinosaur's Rage Special Set",
       "Yu-Gi-Oh! 5D's manga promotional cards",
       'Shonen Jump Vol. 3, Issue 11 promotional card', 'Cosmo Blazer',
       'Crossed Souls Sneak Peek Participation Card',
       'Shonen Jump Vol. 9, Issue 8 promotional card',
       'Hobby League 7 participation card B',
       'Shonen Jump Vol. 5, Issue 6 promotional card',
       'Shonen Jump Vol. 6, Issue 9 promotional card',
       "Structure Deck: Dinosaur's Rage Special Edition",
       'Hobby League 6 participation card C',
       'Ancient Prophecy Sneak Peek Participation Card',
       'Shonen Jump Vol. 6, Issue 1 promotional card',
       'Tournament Pack 2008 Vol.1',
       'Shonen Jump May 2010 subscription bonus',
       'The Valuable Book character cards', 'Academy Duel Disk',
       'Duel Disk', 'Shonen Jump Vol. 4, Issue 2 promotional card',
       'Shonen Jump Vol. 7, Issue 11 promotional card',
       'Ultimate Edition', 'Hobby League 7 participation card C',
       'Shonen Jump Vol. 9, Issue 10 promotional card',
       'Banzai! promotional cards', 'Curse of Anubis',
       'Shonen Jump Championship Series Prize Cards',
       'Shonen Jump Vol. 9, Issue 1 promotional card',
       'Hobby League 6 participation card D',
       'Tournament Pack 2008 Vol.2',
       'Hobby League 7 participation card D',
       'Shonen Jump Vol. 10, Issue 1 promotional card',
       'Ancient Sanctuary',
       'Shonen Jump Vol. 7, Issue 6 promotional card',
       'Hobby League 6 participation card E', 'Magic Ruler',
       'Shonen Jump Vol. 4, Issue 11 promotional card',
       'National Championship 2011',
       'Shonen Jump Vol. 10, Issue 3 promotional card',
       'Shonen Jump Vol. 3, Issue 6 promotional card',
       'Hobby League 6 participation card F',
       'Shonen Jump Vol. 9, Issue 4 promotional card',
       'National Championship 2012',
       'Shonen Jump Vol. 4, Issue 12 promotional card',
       'Yu-Gi-Oh! Championship Series Prize Cards',
       'Shonen Jump Vol. 6, Issue 5 promotional card',
       'Yu-Gi-Oh! The Official Magazine promotional cards',
       'Hobby League 6 participation card A',
       'Shonen Jump December 2010 subscription bonus',
       '2013 Collectible Tins', '20th Anniversary Duel Set',
       'Booster Pack Tin Series Promos',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Collectible Tins 2005', 'Collectible Tins 2006',
       'Collectible Tins 2007', 'Collectible Tins 2008',
       'Collectible Tins 2008 Wave 2', 'Collectible Tins 2009',
       'Collectible Tins 2010', 'Collectible Tins 2011',
       'Collectible Tins 2012',
       'Continuous Token Gifts Promotional Cards', 'Demo Pack',
       'Duelist League 18 participation cards',
       'Duelist League Series 1 participation cards',
       'Duelist League Series 2 participation cards',
       'Duelist Pack: Yugi', 'Exclusive Pack', 'Ghosts From the Past',
       'Judge promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Has print as rarity¶

array(['Booster 7', 'Structure Deck R: Machine Dragon Re-Volt',
       'Dark Ceremony Edition', 'Booster 4', 'Booster 5', 'Booster 6',
       'Booster 1', 'EX Starter Box'], dtype=object)

Merge failed¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge
155818 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN 2022-12-28 20:46:20 right_only
155819 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN 2014-07-03 18:52:14 right_only
8
array(['2015 Mega-Tins', 'Absolute Powerforce: Special Edition',
       'Absolute Powerforce Plus', ...,
       'Jump Festa 2013 - Promotion Pack A', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)
Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Modification date _merge

HTML export¶

Notebook saved to disk